create table person(
id number(7) primary key,
name varchar2(15) not null,
mobile varchar2(11) not null unique check( length(mobile)=11 ),
telphone varchar2(13) check( telphone like '___%-_______%'),
email varchar2(30) unique check( email like '_%@%_' ),
city varchar2(20),
birthday date
)

drop table person cascade constraint
drop sequence person_seq
create sequence person_seq; 

delete from person where id = 37
insert into person values (person_seq.nextval,'王五','08989898999','0999-9898876','wangwu@qq','吉林',to_date('1988-09-10','yyyy-mm-dd'))
select * from person